package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class ClassesTopicDBTable {
    public static final String TABLE_NAME = "ClassesTopic";

    public static final String ID = "classes_topic_id";
    public static final String TOPIC = "classes_topic";
    public static final String IS_DONE = "classes_topic_is_done";
    public static final String FK_LESSON_PROGRAM_ID = "classes_topic_fk_lesson_topic_id";

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        TOPIC + " TEXT NOT NULL, " +
                        IS_DONE + " INTEGER NOT NULL, " +
                        FK_LESSON_PROGRAM_ID + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }
}